1 -- T193874: Add new indexes to change_tag table using ct_tag_id instead of ct_tag
3 define mw_prefix
='{$wgDBprefix}';
5 CREATE UNIQUE INDEX &mw_prefix.change_tag_u04
ON &mw_prefix.
change_tag (ct_rc_id
,ct_tag_id
);
6 CREATE UNIQUE INDEX &mw_prefix.change_tag_u05
ON &mw_prefix.
change_tag (ct_log_id
,ct_tag_id
);
7 CREATE UNIQUE INDEX &mw_prefix.change_tag_u06
ON &mw_prefix.
change_tag (ct_rev_id
,ct_tag_id
);
9 CREATE INDEX &mw_prefix.change_tag_i03
ON &mw_prefix.
change_tag (ct_rc_id
,ct_tag
);
10 CREATE INDEX &mw_prefix.change_tag_i04
ON &mw_prefix.
change_tag (ct_log_id
,ct_tag
);
11 CREATE INDEX &mw_prefix.change_tag_i05
ON &mw_prefix.
change_tag (ct_rev_id
,ct_tag
);
13 DROP INDEX &mw_prefix.change_tag_u01
;
14 DROP INDEX &mw_prefix.change_tag_u02
;
15 DROP INDEX &mw_prefix.change_tag_u03
;
17 ALTER TABLE &mw_prefix.change_tag
18 MODIFY ct_tag
DEFAULT '///invalid///';